<%-- 
    Document   : adminLeftContent
    Created on : Mar 28, 2014, 6:37:58 PM
    Author     : mosta
--%>
<%@ taglib prefix="sql" uri="http://java.sun.com/jstl/sql" %>
<sql:setDataSource driver="com.mysql.jdbc.Driver"
                   url="jdbc:mysql://localhost/Commerce"
                   user="root"  password="root"/>
<sql:query var="users">
    SELECT cat_id,cat_name from category;
</sql:query>
<div class="left_content">
    <div class="title_box">Book Categories</div>
    <ul class="left_menu">
        <c:forEach items="${users.rows}" var="row">
            <li class="odd"><a href="ViewCategory?id=<c:out value="${row.cat_id}"/>"/> <c:out value="${row.cat_name}"/></a></li>
        </c:forEach>
        <li class="odd"></li>
    </ul>
</div>
